![]() | ![]() | ![]() | ![]() |
When you run a procedure against a SAS Information Map, you might see errors that are similar to the following:
Error while submitting SAS code 17 ( case when table1.Age in (-1, 11, 12, 14, 15, 16) then 999 else 13 end ) IN ( (-1), _ 22 76 ERROR 22-322: Syntax error, expecting one of the following: (, SELECT. ERROR 76-322: Syntax error, statement will be ignored.
This error occurs if the information map includes an expression that references negative numbers in an IN clause. For example, if you insert a data item with the following expression into the information map, the error occurs when you attempt to run a procedure against the information map.
To resolve this issue, add the following option to the JREOPTIONS section of your sasv9.cfg
file. You must be running SAS® 9.4_M2 or later to use the option.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
SAS System | Base SAS | Aster Data nCluster on Linux x64 | 9.3 TS1M0 | 9.4 TS1M2 |
DB2 Universal Database on AIX | 9.3 TS1M0 | 9.4 TS1M2 | ||
DB2 Universal Database on Linux x64 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Greenplum on Linux x64 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Netezza TwinFin 32bit blade | 9.3 TS1M0 | 9.4 TS1M2 | ||
Netezza TwinFin 32-bit SMP Hosts | 9.3 TS1M0 | 9.4 TS1M2 | ||
Netezza TwinFin 64-bit S-Blades | 9.3 TS1M0 | 9.4 TS1M2 | ||
Netezza TwinFin 64-bit SMP Hosts | 9.3 TS1M0 | 9.4 TS1M2 | ||
Teradata on Linux | 9.3 TS1M0 | 9.4 TS1M2 | ||
z/OS | 9.3 TS1M0 | 9.4 TS1M2 | ||
Z64 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Microsoft® Windows® for x64 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | |||
Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | |||
Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | |||
Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | |||
Microsoft Windows Server 2008 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Microsoft Windows Server 2008 R2 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Microsoft Windows XP Professional | 9.3 TS1M0 | |||
Windows 7 Enterprise 32 bit | 9.3 TS1M0 | 9.4 TS1M2 | ||
Windows 7 Enterprise x64 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Windows 7 Home Premium 32 bit | 9.3 TS1M0 | 9.4 TS1M2 | ||
Windows 7 Home Premium x64 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Windows 7 Professional 32 bit | 9.3 TS1M0 | 9.4 TS1M2 | ||
Windows 7 Professional x64 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Windows 7 Ultimate 32 bit | 9.3 TS1M0 | 9.4 TS1M2 | ||
Windows 7 Ultimate x64 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Windows Vista | 9.3 TS1M0 | |||
Windows Vista for x64 | 9.3 TS1M0 | |||
64-bit Enabled AIX | 9.3 TS1M0 | 9.4 TS1M2 | ||
64-bit Enabled HP-UX | 9.3 TS1M0 | 9.4 TS1M2 | ||
64-bit Enabled Solaris | 9.3 TS1M0 | 9.4 TS1M2 | ||
HP-UX IPF | 9.3 TS1M0 | 9.4 TS1M2 | ||
Linux | 9.3 TS1M0 | 9.4 TS1M2 | ||
Linux for x64 | 9.3 TS1M0 | 9.4 TS1M2 | ||
Solaris for x64 | 9.3 TS1M0 | 9.4 TS1M2 |